﻿    CREATE TABLE [blog_Widget] (
		[widgetID] INTEGER IDENTITY (1, 1) NOT NULL ,
		[widget_Name] TEXT(50) NOT NULL ,
		[widget_Title] TEXT(50) NOT NULL ,
		[widget_Hidden] BIT NOT NULL ,
		[widget_Type] INTEGER NOT NULL ,
		[widget_Order] INTEGER NOT NULL ,
		[widget_Rate] INTEGER NOT NULL ,
		[widget_InstallTime] DATETIME NOT NULL ,
		[widget_IsInstall] BIT NOT NULL ,
		[widget_Content] TEXT NOT NULL ,
		[widget_IsSystem] BIT NOT NULL,
		PRIMARY KEY (widgetID)
    );
    CREATE TABLE [blog_Tag] (
		[tag_ID] INTEGER IDENTITY (1, 1) NOT NULL ,
		[log_ID] INTEGER NOT NULL ,
		[tag_Name] TEXT(50) NOT NULL,
		PRIMARY KEY (tag_ID)
    );
    ALTER TABLE [blog_Article]  ADD COLUMN log_IsTop BIT NOT NULL;
    ALTER TABLE [blog_Article]  ADD COLUMN log_EnableRss BIT NOT NULL;
   
INSERT INTO [blog_settings] ([set_name], [set_type], [set_value0], [set_value1])  VALUES ('foot','1','0','power by clingingboy clingingboy@gmail.com');
INSERT INTO [blog_settings] ([set_name], [set_type], [set_value0], [set_value1])  VALUES ('enableAjax','1','1','');
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem) VALUES ('panelCategory','Category',0,2,1,1,'2000/1/1 0:00:00',1,'$blog_PanelCategory$',0);
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem)  VALUES ('panelUser','用户面板',0,0,0,1,'2000/1/1 0:00:00',1,'$blog_PanelUser$',0);
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem)  VALUES ('panelComment','Recent Comments',0,0,3,1,'2000/1/1 0:00:00',1,'$blog_PanelComment$',0);
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem)  VALUES ('panelLinks','Links',0,0,6,1,'2000/1/1 0:00:00',1,'$blog_PanelLink$',0);
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem)  VALUES ('panelArchive','Archive',0,0,7,1,'2000/1/1 0:00:00',1,'$blog_PanelArchive$',0);
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem)  VALUES ('panelArticle','Recent Articles',0,2,2,1,'2000/1/1 0:00:00',1,'$blog_PanelArticle$',0);
INSERT INTO [blog_Widget] (widget_Name,widget_Title,widget_Hidden,widget_Type,widget_Order,widget_Rate,widget_InstallTime,widget_IsInstall,widget_Content,widget_IsSystem)  VALUES ('panelStats','Statistics',0,2,5,1,'2000/1/1 0:00:00',1,'$blog_PanelStatus$',0);
